set nocount on
--APOLLO
if object_id('tempdb.dbo.#header','U') is not null
	drop table #header
create table #header (id int identity primary key, line varchar(80))
insert #header 
select 'top 10 most recompiled stored procedures on during the ' 
	+ cast(datediff(n, min(StartTime), max(StartTime)) as varchar(10)) 
	+ ' minutes'
from recompiles_apollo
insert #header 
select 'between ' + cast(min(StartTime) as varchar(20)) 
	+ ' and ' +  cast(max(StartTime) as varchar(20))
from recompiles_apollo
select line from #header order by id

select top 10 'APOLLO', databaseid, cast(TextData as varchar(50)) as [Procedure Name], count(*) as [Number of recompiles]  
from recompiles_apollo
group by cast(TextData as varchar(50)), databaseid
order by count(*) desc

select top 10 'ATHENA', databaseid, cast(TextData as varchar(50)) as [Procedure Name], count(*) as [Number of recompiles]  
from recompiles_athena
where cast(TextData as varchar(50)) is not null
group by cast(TextData as varchar(50)), databaseid
order by count(*) desc

select top 10 'ZEUS', databaseid, cast(TextData as varchar(50)) as [Procedure Name], count(*) as [Number of recompiles]  
from recompiles_zeus
group by cast(TextData as varchar(50)), databaseid
order by count(*) desc